Re: Problems Making a CF DSN to SQL Server

2005-10-19 Thread Mickael Elmalem
Hi Joe, Do you know where I can get those updates? Are they cumulative, so that if I install the lastone it will be enough? Hi Mickael, Have you made sure that the most recent SQL server updates are installed? I've had this exact problem after installing recent CF JDBC drivers. -Joe On

Re: Problems Making a CF DSN to SQL Server

2005-10-19 Thread Mickael Elmalem
Hi Mark, I have tried, localhost, my machine name also 127.0.0.1 Nothing helps. It is really strange. Mickael, Add an entry in your host file for your machine - or use localhost or 127.0.0.1. When you say my machine name' you are really talking about an NBT name - and the JDBC system would

RE: Problems Making a CF DSN to SQL Server

2005-10-19 Thread Michael T. Tangorre
From: Mickael Elmalem [mailto:[EMAIL PROTECTED] Do you know where I can get those updates? Are they cumulative, so that if I install the lastone it will be enough? http://www.microsoft.com/downloads/details.aspx?FamilyID=8E2DFC8D-C20E-4446- 99A9-B7F0213F8BC5displaylang=en Mike

Re: Problems Making a CF DSN to SQL Server

2005-10-19 Thread Mickael Elmalem
One thing that I forgot to add that may be important is the I restored this database from a backup. I created a new user in SQL and gave them owner permission to the database. And used the new username for my CF DSN Connection. I tried the exact same steps on CF7 with the same restore and it

Re: Problems Making a CF DSN to SQL Server

2005-10-19 Thread Mickael Elmalem
Thanks Mike This did the trick From: Mickael Elmalem [mailto:[EMAIL PROTECTED] Do you know where I can get those updates? Are they cumulative, so that if I install the lastone it will be enough? http://www.microsoft.com/downloads/details.aspx?FamilyID=8E2DFC8D-C20E-4446-

Re: Problems Making a CF DSN to SQL Server

2005-10-18 Thread Joe Rinehart
Hi Mickael, Have you made sure that the most recent SQL server updates are installed? I've had this exact problem after installing recent CF JDBC drivers. -Joe On 10/18/05, Mickael Elmalem [EMAIL PROTECTED] wrote: Hello All, I need to do some work on a clients site locally on my machine.

RE: Problems Making a CF DSN to SQL Server

2005-10-18 Thread Mark A Kruger
Mickael, Add an entry in your host file for your machine - or use localhost or 127.0.0.1. When you say my machine name' you are really talking about an NBT name - and the JDBC system would not be able to resolve that. It uses (in order) HOSTS file, DNS and IP. -Mark -Original Message-

RE: Problems Making a CF DSN to SQL Server

2005-10-18 Thread Mark A Kruger
Mickael, Also, using the server network utility (part of SQL server tools) unload the mixed protocol and named pipes - leaving ONLY tcip/ip. -Mark -Original Message- From: Mickael Elmalem [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 18, 2005 3:07 PM To: CF-Talk Subject: Problems