Showing posts with label connection. Show all posts

Tuesday, March 27, 2012

Can''t get IntegratedSecurity with JDBC driver

Hi;

I used SQLServerDatabaseMetaData (which requires a connection to return this data which seems unnecessary) to get:

name: Microsoft SQL Server 2005 JDBC Driver
version: 1.1.1501.101
Passing a url of: jdbc:sqlserver://localhost:1433;DatabaseName=Northwind;IntegratedSecurity=true

I get the error:
Oct 7, 2006 3:46:09 PM com.microsoft.sqlserver.jdbc.AuthenticationJNI <clinit>
WARNING: Failed to load the sqljdbc_auth.dll
Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.

I copied over x86\sqljdbc_auth.dll and then it worked. I assume this is required with the jar file. This leads to a couple of questions:

What are the files xa\x86\sqljdbc_xa.dll & x64 files for? Are they needed? The jar file can just travel with my java code. Should the dll do the same or does it need to be in the path and/or the default directory? Are there any other files needed or just these two?

thanks - dave

Take a look at the following msdn link

http://msdn2.microsoft.com/en-us/library/ms378428.aspx

http://msdn2.microsoft.com/en-us/library/ms378672.aspx

Hope this helps

|||

sqljdbc_xa dll is for xa transactions. YOu do not need them if you are not using XA transactions.

The intgrated auth dll is required (sqljdbc_auth.dll) if you are using integrated authentication. See the links raj provided to see where to place this dll.

Those are the only two files outside of the jar.

|||

I am working on the windows authentication on a windows 2003 server. So i used the 64 sqljdbs_auth.dll and rebooted . I still get "WARNING: Failed to load the sqljdbc_auth.dll" and i cannot do a windows authnetication.

I do have the dll in the system pth adn have copied the dll to C:\windows\system32 as well. Any ideas?

thanks!

|||Are you using 64 bits version of windows 2003?|||

Hi, Dave,

Where did you copy the sqljdbc_auth.dll? The directions say to "copy the file to a directory on the Windows system path on the computer where the JDBC driver is installed." The statement confuses me a little. Did you copy the file to a specific location or just any location that happens to be in the path?

Thanks,

Stephanie

|||I copied it to the same directory as the jar file.|||I've copied these dll's all over the file system (including WINNT, system32, and the directory the jar file is in) and I still get WARNING: Failed to load the sqljdbc_auth.dll
Is there a call to the object you can make to get this file to load?

Paul|||The reason I asked about making an object call is because of the error statement I get that reads:
SQLException: This driver is not configured for integrated authentication.

How might I configure it?
My connection string is just
"jdbc:sqlserver://serverName:1433;integratedSecurity=true;"|||

Does the instructions at http://msdn2.microsoft.com/en-us/library/ms378428.aspx help. I'll copy them on this post to relieve some of the confusion. Please pay particular attention to the last suggestion about using the –Djava.library.path explicitly. This will allow you to put the dll in one location on your computer and then point the java executable to it such as:

Java.exe –Djava.libary.path="C:\jdbc\" HelloWorld In the above example the dll will be in the C:\jdbc\ directory and your application is called HelloWorld. Connecting with Integrated Authentication The JDBC driver supports the use of Type 2 integrated authentication on Windows operating systems through the integratedSecurity connection string property. To use integrated authentication, copy the sqljdbc_auth.dll file to a directory on the Windows system path on the computer where the JDBC driver is installed. The sqljdbc_auth.dll files are installed in the following location: <installation directory>\sqljdbc_<version>\<language>\auth\ Note: On a 32-bit processor, use the sqljdbc_auth.dll file in the x86 folder. On a 64-bit processor, use the sqljdbc_auth.dll file in the x64 folder. Alternatively you can set the java.libary.path system property to specify the directory of the sqljdbc_auth.dll. For example, if the JDBC driver is installed in the default directory, you can specify the location of the DLL by using the following virtual machine (VM) argument when the Java application is started: -Djava.library.path=C:\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_<version>\enu\auth\x86 Regards, Jaaved Mohammed

|||

Hi,

My sqljdbc.jar is located in the following directory

C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu

And I copied x86 directory from C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\auth

And used following steps to establish database connection

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String connectionUrl = "jdbc:sqlserver://localhost:1433;IntegratedSecurity=true;";
Connection con = DriverManager.getConnection(connectionUrl);

and getting the following error

Mar 26, 2007 12:51:50 PM com.microsoft.sqlserver.jdbc.AuthenticationJNI <clinit>
WARNING: Failed to load the sqljdbc_auth.dll
com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at testproject.JdbcDriverTest.main(JdbcDriverTest.java:60)

Please help me out in fixing this issue.

Thanks

Purnima

|||

Purnima,

Did you try the recommendations that I gave above. Did you copy the entire x86 directory to the new location or just the contents of the x86 directory?

Thanks,

Jaaved Mohammed [MSFT]

|||

I copied entire x86 dierctory to the new location.

Thanks

Purnima

|||

hi denial

i am getting same problem and unable to

sort the error

will u please tell me how to sort out this probl,me

where exactle i have to copy sqljdbc_auth.dll.

pleasse replay soon

|||I follow the instruction in connection sample and add the dll path to java command to avoid sqljdbc_auth.dll cannot load error but I got the wrong data. I am using Windows XP SP2 PRO and SQL Server 2005 which is installed in Windows 2003 Server.

connect.java is my filename that i used to test the jdbc connection.
I compiled the connect.java successfully without error but when I run it using java command I got this funny output.

C:\>java -Djava.library.path=C:\Java\tools\sql2005jdbc\sqljdbc_1.2\enu\auth\x86 connect
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20

Please help with this error.

Can''t get IntegratedSecurity with JDBC driver

Hi;

I used SQLServerDatabaseMetaData (which requires a connection to return this data which seems unnecessary) to get:

name: Microsoft SQL Server 2005 JDBC Driver
version: 1.1.1501.101
Passing a url of: jdbc:sqlserver://localhost:1433;DatabaseName=Northwind;IntegratedSecurity=true

I copied over x86\sqljdbc_auth.dll and then it worked. I assume this is required with the jar file. This leads to a couple of questions:

thanks - dave

Take a look at the following msdn link

http://msdn2.microsoft.com/en-us/library/ms378428.aspx

http://msdn2.microsoft.com/en-us/library/ms378672.aspx

Hope this helps

|||

sqljdbc_xa dll is for xa transactions. YOu do not need them if you are not using XA transactions.

The intgrated auth dll is required (sqljdbc_auth.dll) if you are using integrated authentication. See the links raj provided to see where to place this dll.

Those are the only two files outside of the jar.

|||

I do have the dll in the system pth adn have copied the dll to C:\windows\system32 as well. Any ideas?

thanks!

|||Are you using 64 bits version of windows 2003?|||

Hi, Dave,

Thanks,

Stephanie

Paul|||The reason I asked about making an object call is because of the error statement I get that reads:
SQLException: This driver is not configured for integrated authentication.

How might I configure it?
My connection string is just
"jdbc:sqlserver://serverName:1433;integratedSecurity=true;"|||

|||

Hi,

My sqljdbc.jar is located in the following directory

C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu

And I copied x86 directory from C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\auth

And used following steps to establish database connection

and getting the following error

Please help me out in fixing this issue.

Thanks

Purnima

|||

Purnima,

Did you try the recommendations that I gave above. Did you copy the entire x86 directory to the new location or just the contents of the x86 directory?

Thanks,

Jaaved Mohammed [MSFT]

|||

I copied entire x86 dierctory to the new location.

Thanks

Purnima

|||

hi denial

i am getting same problem and unable to

sort the error

will u please tell me how to sort out this probl,me

where exactle i have to copy sqljdbc_auth.dll.

pleasse replay soon

connect.java is my filename that i used to test the jdbc connection.
I compiled the connect.java successfully without error but when I run it using java command I got this funny output.

C:\>java -Djava.library.path=C:\Java\tools\sql2005jdbc\sqljdbc_1.2\enu\auth\x86 connect
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20

Please help with this error.

Can''t get IntegratedSecurity with JDBC driver

Hi;

I used SQLServerDatabaseMetaData (which requires a connection to return this data which seems unnecessary) to get:

name: Microsoft SQL Server 2005 JDBC Driver
version: 1.1.1501.101
Passing a url of: jdbc:sqlserver://localhost:1433;DatabaseName=Northwind;IntegratedSecurity=true

I copied over x86\sqljdbc_auth.dll and then it worked. I assume this is required with the jar file. This leads to a couple of questions:

thanks - dave

Take a look at the following msdn link

http://msdn2.microsoft.com/en-us/library/ms378428.aspx

http://msdn2.microsoft.com/en-us/library/ms378672.aspx

Hope this helps

|||

sqljdbc_xa dll is for xa transactions. YOu do not need them if you are not using XA transactions.

The intgrated auth dll is required (sqljdbc_auth.dll) if you are using integrated authentication. See the links raj provided to see where to place this dll.

Those are the only two files outside of the jar.

|||

I do have the dll in the system pth adn have copied the dll to C:\windows\system32 as well. Any ideas?

thanks!

|||Are you using 64 bits version of windows 2003?|||

Hi, Dave,

Thanks,

Stephanie

Paul|||The reason I asked about making an object call is because of the error statement I get that reads:
SQLException: This driver is not configured for integrated authentication.

How might I configure it?
My connection string is just
"jdbc:sqlserver://serverName:1433;integratedSecurity=true;"|||

|||

Hi,

My sqljdbc.jar is located in the following directory

C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu

And I copied x86 directory from C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\auth

And used following steps to establish database connection

and getting the following error

Please help me out in fixing this issue.

Thanks

Purnima

|||

Purnima,

Did you try the recommendations that I gave above. Did you copy the entire x86 directory to the new location or just the contents of the x86 directory?

Thanks,

Jaaved Mohammed [MSFT]

|||

I copied entire x86 dierctory to the new location.

Thanks

Purnima

|||

hi denial

i am getting same problem and unable to

sort the error

will u please tell me how to sort out this probl,me

where exactle i have to copy sqljdbc_auth.dll.

pleasse replay soon

connect.java is my filename that i used to test the jdbc connection.
I compiled the connect.java successfully without error but when I run it using java command I got this funny output.

C:\>java -Djava.library.path=C:\Java\tools\sql2005jdbc\sqljdbc_1.2\enu\auth\x86 connect
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20

Please help with this error.

Can''t get IntegratedSecurity with JDBC driver

Hi;

I used SQLServerDatabaseMetaData (which requires a connection to return this data which seems unnecessary) to get:

name: Microsoft SQL Server 2005 JDBC Driver
version: 1.1.1501.101
Passing a url of: jdbc:sqlserver://localhost:1433;DatabaseName=Northwind;IntegratedSecurity=true

I copied over x86\sqljdbc_auth.dll and then it worked. I assume this is required with the jar file. This leads to a couple of questions:

thanks - dave

Take a look at the following msdn link

http://msdn2.microsoft.com/en-us/library/ms378428.aspx

http://msdn2.microsoft.com/en-us/library/ms378672.aspx

Hope this helps

|||

sqljdbc_xa dll is for xa transactions. YOu do not need them if you are not using XA transactions.

The intgrated auth dll is required (sqljdbc_auth.dll) if you are using integrated authentication. See the links raj provided to see where to place this dll.

Those are the only two files outside of the jar.

|||

I do have the dll in the system pth adn have copied the dll to C:\windows\system32 as well. Any ideas?

thanks!

|||Are you using 64 bits version of windows 2003?|||

Hi, Dave,

Thanks,

Stephanie

Paul|||The reason I asked about making an object call is because of the error statement I get that reads:
SQLException: This driver is not configured for integrated authentication.

How might I configure it?
My connection string is just
"jdbc:sqlserver://serverName:1433;integratedSecurity=true;"|||

|||

Hi,

My sqljdbc.jar is located in the following directory

C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu

And I copied x86 directory from C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\auth

And used following steps to establish database connection

and getting the following error

Please help me out in fixing this issue.

Thanks

Purnima

|||

Purnima,

Did you try the recommendations that I gave above. Did you copy the entire x86 directory to the new location or just the contents of the x86 directory?

Thanks,

Jaaved Mohammed [MSFT]

|||

I copied entire x86 dierctory to the new location.

Thanks

Purnima

|||

hi denial

i am getting same problem and unable to

sort the error

will u please tell me how to sort out this probl,me

where exactle i have to copy sqljdbc_auth.dll.

pleasse replay soon

connect.java is my filename that i used to test the jdbc connection.
I compiled the connect.java successfully without error but when I run it using java command I got this funny output.

C:\>java -Djava.library.path=C:\Java\tools\sql2005jdbc\sqljdbc_1.2\enu\auth\x86 connect
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20

Please help with this error.
sql

Can''t get IntegratedSecurity with JDBC driver

Hi;

I used SQLServerDatabaseMetaData (which requires a connection to return this data which seems unnecessary) to get:

name: Microsoft SQL Server 2005 JDBC Driver
version: 1.1.1501.101
Passing a url of: jdbc:sqlserver://localhost:1433;DatabaseName=Northwind;IntegratedSecurity=true

I copied over x86\sqljdbc_auth.dll and then it worked. I assume this is required with the jar file. This leads to a couple of questions:

thanks - dave

Take a look at the following msdn link

http://msdn2.microsoft.com/en-us/library/ms378428.aspx

http://msdn2.microsoft.com/en-us/library/ms378672.aspx

Hope this helps

|||

sqljdbc_xa dll is for xa transactions. YOu do not need them if you are not using XA transactions.

The intgrated auth dll is required (sqljdbc_auth.dll) if you are using integrated authentication. See the links raj provided to see where to place this dll.

Those are the only two files outside of the jar.

|||

I do have the dll in the system pth adn have copied the dll to C:\windows\system32 as well. Any ideas?

thanks!

|||Are you using 64 bits version of windows 2003?|||

Hi, Dave,

Thanks,

Stephanie

Paul|||The reason I asked about making an object call is because of the error statement I get that reads:
SQLException: This driver is not configured for integrated authentication.

How might I configure it?
My connection string is just
"jdbc:sqlserver://serverName:1433;integratedSecurity=true;"|||

|||

Hi,

My sqljdbc.jar is located in the following directory

C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu

And I copied x86 directory from C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\auth

And used following steps to establish database connection

and getting the following error

Please help me out in fixing this issue.

Thanks

Purnima

|||

Purnima,

Did you try the recommendations that I gave above. Did you copy the entire x86 directory to the new location or just the contents of the x86 directory?

Thanks,

Jaaved Mohammed [MSFT]

|||

I copied entire x86 dierctory to the new location.

Thanks

Purnima

|||

hi denial

i am getting same problem and unable to

sort the error

will u please tell me how to sort out this probl,me

where exactle i have to copy sqljdbc_auth.dll.

pleasse replay soon

connect.java is my filename that i used to test the jdbc connection.
I compiled the connect.java successfully without error but when I run it using java command I got this funny output.

C:\>java -Djava.library.path=C:\Java\tools\sql2005jdbc\sqljdbc_1.2\enu\auth\x86 connect
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20

Please help with this error.

Can't get IntegratedSecurity with JDBC driver

Hi;

I used SQLServerDatabaseMetaData (which requires a connection to return this data which seems unnecessary) to get:

name: Microsoft SQL Server 2005 JDBC Driver
version: 1.1.1501.101
Passing a url of: jdbc:sqlserver://localhost:1433;DatabaseName=Northwind;IntegratedSecurity=true

I copied over x86\sqljdbc_auth.dll and then it worked. I assume this is required with the jar file. This leads to a couple of questions:

What are the files xa\x86\sqljdbc_xa.dll & x64 files for? Are they needed?

The jar file can just travel with my java code. Should the dll do the same or does it need to be in the path and/or the default directory?

Are there any other files needed or just these two?

thanks - dave

Take a look at the following msdn link

http://msdn2.microsoft.com/en-us/library/ms378428.aspx

http://msdn2.microsoft.com/en-us/library/ms378672.aspx

Hope this helps

|||

sqljdbc_xa dll is for xa transactions. YOu do not need them if you are not using XA transactions.

The intgrated auth dll is required (sqljdbc_auth.dll) if you are using integrated authentication. See the links raj provided to see where to place this dll.

Those are the only two files outside of the jar.

|||

I do have the dll in the system pth adn have copied the dll to C:\windows\system32 as well. Any ideas?

thanks!

|||Are you using 64 bits version of windows 2003?|||

Hi, Dave,

Thanks,

Stephanie

Paul|||The reason I asked about making an object call is because of the error statement I get that reads:
SQLException: This driver is not configured for integrated authentication.

How might I configure it?
My connection string is just
"jdbc:sqlserver://serverName:1433;integratedSecurity=true;"|||

Java.exe –Djava.libary.path="C:\jdbc\" HelloWorld

In the above example the dll will be in the C:\jdbc\ directory and your application is called HelloWorld.

`Connecting with Integrated Authentication`

The JDBC driver supports the use of Type 2 integrated authentication on Windows operating systems through the integratedSecurity connection string property. To use integrated authentication, copy the sqljdbc_auth.dll file to a directory on the Windows system path on the computer where the JDBC driver is installed.

The sqljdbc_auth.dll files are installed in the following location:

<installation directory>\sqljdbc_<version>\<language>\auth\

Note: On a 32-bit processor, use the sqljdbc_auth.dll file in the x86 folder. On a 64-bit processor, use the sqljdbc_auth.dll file in the x64 folder.

Alternatively you can set the java.libary.path system property to specify the directory of the sqljdbc_auth.dll. For example, if the JDBC driver is installed in the default directory, you can specify the location of the DLL by using the following virtual machine (VM) argument when the Java application is started:

-Djava.library.path=C:\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_<version>\enu\auth\x86

Regards,

Jaaved Mohammed

|||

Hi,

My sqljdbc.jar is located in the following directory

C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu

And I copied x86 directory from C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\auth

And used following steps to establish database connection

and getting the following error

Please help me out in fixing this issue.

Thanks

Purnima

|||

Purnima,

Did you try the recommendations that I gave above. Did you copy the entire x86 directory to the new location or just the contents of the x86 directory?

Thanks,

Jaaved Mohammed [MSFT]

|||

I copied entire x86 dierctory to the new location.

Thanks

Purnima

|||

hi denial

i am getting same problem and unable to

sort the error

will u please tell me how to sort out this probl,me

where exactle i have to copy sqljdbc_auth.dll.

pleasse replay soon

connect.java is my filename that i used to test the jdbc connection.
I compiled the connect.java successfully without error but when I run it using java command I got this funny output.

C:\>java -Djava.library.path=C:\Java\tools\sql2005jdbc\sqljdbc_1.2\enu\auth\x86 connect
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20

Please help with this error.

Can't get IntegratedSecurity with JDBC driver

Hi;

I used SQLServerDatabaseMetaData (which requires a connection to return this data which seems unnecessary) to get:

name: Microsoft SQL Server 2005 JDBC Driver
version: 1.1.1501.101
Passing a url of: jdbc:sqlserver://localhost:1433;DatabaseName=Northwind;IntegratedSecurity=true

I copied over x86\sqljdbc_auth.dll and then it worked. I assume this is required with the jar file. This leads to a couple of questions:

What are the files xa\x86\sqljdbc_xa.dll & x64 files for? Are they needed?

The jar file can just travel with my java code. Should the dll do the same or does it need to be in the path and/or the default directory?

Are there any other files needed or just these two?

thanks - dave

Take a look at the following msdn link

http://msdn2.microsoft.com/en-us/library/ms378428.aspx

http://msdn2.microsoft.com/en-us/library/ms378672.aspx

Hope this helps

|||

sqljdbc_xa dll is for xa transactions. YOu do not need them if you are not using XA transactions.

The intgrated auth dll is required (sqljdbc_auth.dll) if you are using integrated authentication. See the links raj provided to see where to place this dll.

Those are the only two files outside of the jar.

|||

I do have the dll in the system pth adn have copied the dll to C:\windows\system32 as well. Any ideas?

thanks!

|||Are you using 64 bits version of windows 2003?|||

Hi, Dave,

Thanks,

Stephanie

Paul|||The reason I asked about making an object call is because of the error statement I get that reads:
SQLException: This driver is not configured for integrated authentication.

How might I configure it?
My connection string is just
"jdbc:sqlserver://serverName:1433;integratedSecurity=true;"|||

Java.exe –Djava.libary.path="C:\jdbc\" HelloWorld

In the above example the dll will be in the C:\jdbc\ directory and your application is called HelloWorld.

`Connecting with Integrated Authentication`

The sqljdbc_auth.dll files are installed in the following location:

<installation directory>\sqljdbc_<version>\<language>\auth\

Note: On a 32-bit processor, use the sqljdbc_auth.dll file in the x86 folder. On a 64-bit processor, use the sqljdbc_auth.dll file in the x64 folder.

-Djava.library.path=C:\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_<version>\enu\auth\x86

Regards,

Jaaved Mohammed

|||

Hi,

My sqljdbc.jar is located in the following directory

C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu

And I copied x86 directory from C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\auth

And used following steps to establish database connection

and getting the following error

Please help me out in fixing this issue.

Thanks

Purnima

|||

Purnima,

Did you try the recommendations that I gave above. Did you copy the entire x86 directory to the new location or just the contents of the x86 directory?

Thanks,

Jaaved Mohammed [MSFT]

|||

I copied entire x86 dierctory to the new location.

Thanks

Purnima

|||

hi denial

i am getting same problem and unable to

sort the error

will u please tell me how to sort out this probl,me

where exactle i have to copy sqljdbc_auth.dll.

pleasse replay soon

connect.java is my filename that i used to test the jdbc connection.
I compiled the connect.java successfully without error but when I run it using java command I got this funny output.

C:\>java -Djava.library.path=C:\Java\tools\sql2005jdbc\sqljdbc_1.2\enu\auth\x86 connect
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20

Please help with this error.

Can't get IntegratedSecurity with JDBC driver

Hi;

I used SQLServerDatabaseMetaData (which requires a connection to return this data which seems unnecessary) to get:

name: Microsoft SQL Server 2005 JDBC Driver
version: 1.1.1501.101
Passing a url of: jdbc:sqlserver://localhost:1433;DatabaseName=Northwind;IntegratedSecurity=true

I copied over x86\sqljdbc_auth.dll and then it worked. I assume this is required with the jar file. This leads to a couple of questions:

What are the files xa\x86\sqljdbc_xa.dll & x64 files for? Are they needed?

The jar file can just travel with my java code. Should the dll do the same or does it need to be in the path and/or the default directory?

Are there any other files needed or just these two?

thanks - dave

Take a look at the following msdn link

http://msdn2.microsoft.com/en-us/library/ms378428.aspx

http://msdn2.microsoft.com/en-us/library/ms378672.aspx

Hope this helps

|||

sqljdbc_xa dll is for xa transactions. YOu do not need them if you are not using XA transactions.

The intgrated auth dll is required (sqljdbc_auth.dll) if you are using integrated authentication. See the links raj provided to see where to place this dll.

Those are the only two files outside of the jar.

|||

I do have the dll in the system pth adn have copied the dll to C:\windows\system32 as well. Any ideas?

thanks!

|||Are you using 64 bits version of windows 2003?|||

Hi, Dave,

Thanks,

Stephanie

Paul|||The reason I asked about making an object call is because of the error statement I get that reads:
SQLException: This driver is not configured for integrated authentication.

How might I configure it?
My connection string is just
"jdbc:sqlserver://serverName:1433;integratedSecurity=true;"|||

Java.exe –Djava.libary.path="C:\jdbc\" HelloWorld

In the above example the dll will be in the C:\jdbc\ directory and your application is called HelloWorld.

`Connecting with Integrated Authentication`

The sqljdbc_auth.dll files are installed in the following location:

<installation directory>\sqljdbc_<version>\<language>\auth\

Note: On a 32-bit processor, use the sqljdbc_auth.dll file in the x86 folder. On a 64-bit processor, use the sqljdbc_auth.dll file in the x64 folder.

-Djava.library.path=C:\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_<version>\enu\auth\x86

Regards,

Jaaved Mohammed

|||

Hi,

My sqljdbc.jar is located in the following directory

C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu

And I copied x86 directory from C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\auth

And used following steps to establish database connection

and getting the following error

Please help me out in fixing this issue.

Thanks

Purnima

|||

Purnima,

Did you try the recommendations that I gave above. Did you copy the entire x86 directory to the new location or just the contents of the x86 directory?

Thanks,

Jaaved Mohammed [MSFT]

|||

I copied entire x86 dierctory to the new location.

Thanks

Purnima

|||

hi denial

i am getting same problem and unable to

sort the error

will u please tell me how to sort out this probl,me

where exactle i have to copy sqljdbc_auth.dll.

pleasse replay soon

connect.java is my filename that i used to test the jdbc connection.
I compiled the connect.java successfully without error but when I run it using java command I got this funny output.

C:\>java -Djava.library.path=C:\Java\tools\sql2005jdbc\sqljdbc_1.2\enu\auth\x86 connect
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20

Please help with this error.

Can't get IntegratedSecurity with JDBC driver

Hi;

I used SQLServerDatabaseMetaData (which requires a connection to return this data which seems unnecessary) to get:

name: Microsoft SQL Server 2005 JDBC Driver
version: 1.1.1501.101
Passing a url of: jdbc:sqlserver://localhost:1433;DatabaseName=Northwind;IntegratedSecurity=true

I copied over x86\sqljdbc_auth.dll and then it worked. I assume this is required with the jar file. This leads to a couple of questions:

What are the files xa\x86\sqljdbc_xa.dll & x64 files for? Are they needed?

The jar file can just travel with my java code. Should the dll do the same or does it need to be in the path and/or the default directory?

Are there any other files needed or just these two?

thanks - dave

Take a look at the following msdn link

http://msdn2.microsoft.com/en-us/library/ms378428.aspx

http://msdn2.microsoft.com/en-us/library/ms378672.aspx

Hope this helps

|||

sqljdbc_xa dll is for xa transactions. YOu do not need them if you are not using XA transactions.

The intgrated auth dll is required (sqljdbc_auth.dll) if you are using integrated authentication. See the links raj provided to see where to place this dll.

Those are the only two files outside of the jar.

|||

I do have the dll in the system pth adn have copied the dll to C:\windows\system32 as well. Any ideas?

thanks!

|||Are you using 64 bits version of windows 2003?|||

Hi, Dave,

Thanks,

Stephanie

Paul|||The reason I asked about making an object call is because of the error statement I get that reads:
SQLException: This driver is not configured for integrated authentication.

How might I configure it?
My connection string is just
"jdbc:sqlserver://serverName:1433;integratedSecurity=true;"|||

Java.exe –Djava.libary.path="C:\jdbc\" HelloWorld

In the above example the dll will be in the C:\jdbc\ directory and your application is called HelloWorld.

`Connecting with Integrated Authentication`

The sqljdbc_auth.dll files are installed in the following location:

<installation directory>\sqljdbc_<version>\<language>\auth\

Note: On a 32-bit processor, use the sqljdbc_auth.dll file in the x86 folder. On a 64-bit processor, use the sqljdbc_auth.dll file in the x64 folder.

-Djava.library.path=C:\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_<version>\enu\auth\x86

Regards,

Jaaved Mohammed

|||

Hi,

My sqljdbc.jar is located in the following directory

C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu

And I copied x86 directory from C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\auth

And used following steps to establish database connection

and getting the following error

Please help me out in fixing this issue.

Thanks

Purnima

|||

Purnima,

Did you try the recommendations that I gave above. Did you copy the entire x86 directory to the new location or just the contents of the x86 directory?

Thanks,

Jaaved Mohammed [MSFT]

|||

I copied entire x86 dierctory to the new location.

Thanks

Purnima

|||

hi denial

i am getting same problem and unable to

sort the error

will u please tell me how to sort out this probl,me

where exactle i have to copy sqljdbc_auth.dll.

pleasse replay soon

connect.java is my filename that i used to test the jdbc connection.
I compiled the connect.java successfully without error but when I run it using java command I got this funny output.

C:\>java -Djava.library.path=C:\Java\tools\sql2005jdbc\sqljdbc_1.2\enu\auth\x86 connect
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20
0E-20

Please help with this error.sql

Sunday, March 25, 2012

Can't Generate SSPI

Hi,
I'm trying to configure a Windows Authentication SQL Server user and I get a
message that the compuetr can;t generate an SSPI connection. The Enterprise
Manager then won't connect to the SQL Server. The VS.NET 2003 enviroment, w
hich is the user preferred
connection enviroment to the SQL Server also won't connect.
The user has SQL Server 2000 Develop edition SP3a installed on the computer
and we are trying to connect to a SQL Server 2000 Enterprise edition SP3a. T
he user also has on his computer VS6 and VS.NET 2003.
Does any one know the cause of this problems?
Thanks,Try these links:
http://www.sqlservercentral.com/col...kb;en-us;811889
Ray Higdon MCSE, MCDBA, CCNA
--
"Shai Goldberg" <gshai(removethis)@.shamir.co.il> wrote in message
news:B52289F3-1E9F-410F-B49C-BCB73C80D1AD@.microsoft.com...
> Hi,
> I'm trying to configure a Windows Authentication SQL Server user and I get
a message that the compuetr can;t generate an SSPI connection. The
Enterprise Manager then won't connect to the SQL Server. The VS.NET 2003
enviroment, which is the user preferred connection enviroment to the SQL
Server also won't connect.
> The user has SQL Server 2000 Develop edition SP3a installed on the
computer and we are trying to connect to a SQL Server 2000 Enterprise
edition SP3a. The user also has on his computer VS6 and VS.NET 2003.
> Does any one know the cause of this problems?
> Thanks,|||Thanks,sql

Can't Find SQL Native Client in ODBC Connection Manager in SQL Server Open Database Connectivit

I apologize if this is not the correct forum for this posting. Looking at the descriptions, it appeared to be the best choice.

I am running Windows XP Pro SP2. I have installed the SQL Native Client for

XP. However, when I try to add a new data source through ODBC Connection

Manager, SQL Native Client is not listed as an option. I have followed this procedure on three other systems with no problems. What would be causing the

SQL Native Client to not show up in the list of available ODBC data sources?

Hi, James,

First of all - are you sure that the installation of the SQL Native Client completed successfully? Do you see the packet in the Add/Remove Programs applet? What you can try first is to uninstall (if available) and reinstall the Client, check if any errors or warnings would be reported.

Going further - the ODBC drivers information is stored in the registry. Using regedit, go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI and check if the SQL Native Client driver is present, the entries in the folder as well as an entry at "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers" folder.

If the SQL Native Client driver is not present in the registry, you might have a permission issue. One possible approach is to run and capture a RegMon log during the installation (http://www.microsoft.com/technet/sysinternals/SystemInformation/Regmon.mspx) and see if access to the key above failed.

If the SQL Native Client driver is present in the registry, then for some reason the ODBC Administrator fails to enumerate it or it contains invalid entries. First step would be to compare the entries to a "working" machine and then you could probably use RegMon again - this time when running ODBC Administrator.

Based on the findings, you could take corrective actions and start seeing the driver properly.

HTH,

Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thanks for the reply. SQL Native Client does appear in Add/Remove programs, and I am able to uninstall and reinstall. I will do the other checks you mentioned, and let you know the results. Thanks.|||

I am having a very similar problem. I am using Visual C++ 2005 Express and have installed the Microsoft SQL Server Native Client. All the mentioned registrty entries appear to be correct. I have also include all of the ODBC components in my toolbox. When I try to configure the ODBC data adpater, create a new connection, the only types of data sources that are in the possible list are the SQL Server and Access. If I add an OdbcConnection tool to the form and try to modify the connection string to a new connection, I get a message that the data provider identified by guid "all zeroes" could not be loaded. It would appear that csomething is missing.

I have tried to find a "Data" component to reference in the project that might include the missing component, but have had no success.

Can't Find SQL Native Client in ODBC Connection Manager in SQL Server Open Database Connectivit

I apologize if this is not the correct forum for this posting. Looking at the descriptions, it appeared to be the best choice.

Hi, James,

Based on the findings, you could take corrective actions and start seeing the driver properly.

HTH,

Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

I have tried to find a "Data" component to reference in the project that might include the missing component, but have had no success.

sql

Can't Find SQL Native Client in ODBC Connection Manager

I am running Windows XP Pro SP2. I have installed the SQL Native Client for
XP. However, when I try to add a new data source through ODBC Connection
Manager, SQL Native Client is not listed as an option. I have followed this
procedure on three other systems with no problems. What would be causing the
SQL Native Client to not show up in the list of available ODBC data sources?MDAC issues, related DLL conflicts. The ODBC Data Source
Administrator piece can get hosed out with DLL conflicts on
an MDAC installation. You'd probably want to start checking
the MDAC installation using component checker. You can
download it from:
http://msdn2.microsoft.com/en-us/data/aa937730.aspx
-Sue
On Tue, 13 Feb 2007 10:31:01 -0800, Jim Strickland <Jim
Strickland@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I am running Windows XP Pro SP2. I have installed the SQL Native Client for
>XP. However, when I try to add a new data source through ODBC Connection
>Manager, SQL Native Client is not listed as an option. I have followed this
>procedure on three other systems with no problems. What would be causing th
e
>SQL Native Client to not show up in the list of available ODBC data sources?[/vbcol
]

Can't Find SQL Native Client in ODBC Connection Manager

I am running Windows XP Pro SP2. I have installed the SQL Native Client for
XP. However, when I try to add a new data source through ODBC Connection
Manager, SQL Native Client is not listed as an option. I have followed this
procedure on three other systems with no problems. What would be causing the
SQL Native Client to not show up in the list of available ODBC data sources?
MDAC issues, related DLL conflicts. The ODBC Data Source
Administrator piece can get hosed out with DLL conflicts on
an MDAC installation. You'd probably want to start checking
the MDAC installation using component checker. You can
download it from:
http://msdn2.microsoft.com/en-us/data/aa937730.aspx
-Sue
On Tue, 13 Feb 2007 10:31:01 -0800, Jim Strickland <Jim
Strickland@.discussions.microsoft.com> wrote:

>I am running Windows XP Pro SP2. I have installed the SQL Native Client for
>XP. However, when I try to add a new data source through ODBC Connection
>Manager, SQL Native Client is not listed as an option. I have followed this
>procedure on three other systems with no problems. What would be causing the
>SQL Native Client to not show up in the list of available ODBC data sources?

Thursday, March 22, 2012

Can't find odbcping.exe

I am trying to troubleshoot a SQL Server connection from my home machine
to an instance of SQL server running on my client's network using
Enterprise Manger and I am going through the steps in the MS KB article
How to troubleshoot connectivity issues in SQL Server 2000,
http://support.microsoft.com/default...;en-us;827422, which
suggests using odbcping.exe.
However, I cannot find this in my local SQL Server directories or in the
server Sql Server directories.
Doe anyone know where it is?
It's not installed by default with SQL 2000. The utility can
be found in the \x86\Binn directory on the SQL Server 2000
CD.
-Sue
On Sun, 12 Dec 2004 00:05:34 -0500, Douglas Forrest
<dforrest@.optonline.net> wrote:

>I am trying to troubleshoot a SQL Server connection from my home machine
>to an instance of SQL server running on my client's network using
>Enterprise Manger and I am going through the steps in the MS KB article
>How to troubleshoot connectivity issues in SQL Server 2000,
>http://support.microsoft.com/default...;en-us;827422, which
>suggests using odbcping.exe.
>However, I cannot find this in my local SQL Server directories or in the
>server Sql Server directories.
>Doe anyone know where it is?
|||Sue Hoegemeier wrote:
> It's not installed by default with SQL 2000. The utility can
> be found in the \x86\Binn directory on the SQL Server 2000
> CD.
> -Sue
> On Sun, 12 Dec 2004 00:05:34 -0500, Douglas Forrest
> <dforrest@.optonline.net> wrote:
>
>
Thanks

Monday, March 19, 2012

Can't deploy report on the reporting server

Please help -
I am trying to deploy report on the server - getting following:
===================================
A connection could not be made to the report server
http://169.35.137.96/ReportServer/. (Microsoft Report Designer)
===================================
The server committed a protocol violation. Section=ResponseStatusLine
(Microsoft.ReportingServices.Designer)
--
Program Location:
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String
Item)
at
Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
at
Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String
url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
--
Regadrs,
Andyhello,
Can you connect to RS and Report Manager without any problems in your web
browser using this addresses
http://169.35.137.96/ReportServer/
http://169.35.137.96/Reports/
'
And if so can you deploy any files and create folders in Report Manager?
Regards,
Radoslaw Lebkowski
U¿ytkownik "andys" <asichevoy@.gmail.com.(donotspam)> napisa³ w wiadomo¶ci
news:8A5B8E82-44F9-4FE8-90EB-00F38FB6DB5D@.microsoft.com...
> Please help -
> I am trying to deploy report on the server - getting following:
> ===================================> A connection could not be made to the report server
> http://169.35.137.96/ReportServer/. (Microsoft Report Designer)
> ===================================> The server committed a protocol violation. Section=ResponseStatusLine
> (Microsoft.ReportingServices.Designer)
> --
> Program Location:
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> methodname)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String
> Item)
> at
> Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String
> item)
> at
> Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
> at
> Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String
> url)
> at
> Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
>
>
> --
> Regadrs,
> Andy

Can''t deploy managed assembly to Katmai

Hi!

When I create a managed assembly database project inside Visual Studio 2005 and want to change the database connection to a Katmai server, I get the following error message:

"This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later."

Is this a bug inside Katmai or Visual Studio 2005?

Thanks

Klaus Aschenbrenner

http://www.csharp.at

http://www.csharp.at/blog

Hi Klaus!

That is a bug/feature/something in the VS deployment project :-). You can either deploy manually or use my deployment project from inside VS.

Niels

Can''t deploy managed assembly to Katmai

Hi!

When I create a managed assembly database project inside Visual Studio 2005 and want to change the database connection to a Katmai server, I get the following error message:

"This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later."

Is this a bug inside Katmai or Visual Studio 2005?

Thanks

Klaus Aschenbrenner

http://www.csharp.at

http://www.csharp.at/blog

Hi Klaus!

It's a VS thing. You can either deploy manually, or use my deployment project from within VS to deploy.

Niels
|||

Hi Klaus,

This is a known issue with Visual Studio 2005 / 2008 beta. This will be fixed in a future release of Visual Studio.

As suggested by Neils, you can build your assembly through Visual Studio and deploy it using CREATE ASSEMBLY/CREATE FUNCTION statements from management studio.

Let me know if you need more information.

Thanks,

-Vineet

Wednesday, March 7, 2012

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

Server Explorer -->
Right Click DATA CONNECTIONS -->
Add Connection -->
Datasource=Microsoft SQL Server Mobile Edition--> Data provider = .NET Framework Data Provider for SQL Server Mobile Edition-->
ActiveSync Connected Device

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Here are the things you should check:
1) Did Active Sync detect the connection and turned green?. And, which Active Sync version are you using, Is it the latest or the old?
2) Is your device running the supported Windows CE Version?
3) Are you able to browse files & folders on the device using Windows Explorer?
4) Did you do any uninstallations and installations in the mean time? Check whether the SQL Mobile data provider is listed in .NET Framework config file machine.config.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?
|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.
|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||I have the same problem to at Visual Studio. I try to fix the error using this step.
1. I install the compact framework using NETCFv2.wm.armv4i.cab file. Status done.
2. I install the SQL CE database server using Mobile first, you can find it at folder
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\armv4i
The file list are :
- sqlce30.dev.ENU.ppc.wce5.armv4i.CAB
- sqlce30.ppc.wce5.armv4i.CAB
- sqlce30.repl.ppc.wce5.armv4i.CAB
3. I've got the error like described above, the error also raised on Emulator too, so i uninstall the SQLCE
4. I instal the SQL using Client, you can find it at folder :
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\wce500\armv4i
The file list are :
- sql.dev.ENU.ppc.wce5.armv4i.CAB
- sql.ppc.wce5.armv4i.CAB
5. There no error again on Emulator, but on Visual Studio still have the same error.

Ok then where is the problem, Thanks.

PS: I use WM5 Pocket PC Emulator and the Visual Studio is VS2005
|||If you have uninstalled and reinstalled .NET Fx after VS Installation, this problem would arise. Can you please search for Data Providers in .NET Framework config file.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||1) Did Active Sync detect the connection and turned green?. And, which Active Sync version are you using, Is it the latest or the old?
YES, Version 4.1
2) Is your device running the supported Windows CE Version?
Yes
3) Are you able to browse files & folders on the device using Windows Explorer?
Yes
4) Did you do any uninstallations and installations in the mean time? Check whether the SQL Mobile data provider is listed in .NET Framework config file machine.config.
Yes, it's listed
Any ideas?
Thank you very much...|||I had the same problem. After trying the suggested solutions, I installed it manually and it worked. (see http://msdn2.microsoft.com/en-us/library/ms171875.aspx)|||
Como fa?o para aparecer o Microsoft Sql Server Mobile Edition na tela de Change Data Source?
Teria como me ajudar?
Já instalei tudo e n?o aparece, at mesmo mudei o maching.config e n?o funcionou.
Pode me ajudar?

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?
|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.
|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

Ok then where is the problem, Thanks.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

Tuesday, March 27, 2012

Can''t get IntegratedSecurity with JDBC driver

Connecting with Integrated Authentication

Can''t get IntegratedSecurity with JDBC driver

Connecting with Integrated Authentication

Can''t get IntegratedSecurity with JDBC driver

Connecting with Integrated Authentication

Can''t get IntegratedSecurity with JDBC driver

Connecting with Integrated Authentication

Can''t get IntegratedSecurity with JDBC driver

Connecting with Integrated Authentication

Can't get IntegratedSecurity with JDBC driver

`Connecting with Integrated Authentication`

Can't get IntegratedSecurity with JDBC driver

`Connecting with Integrated Authentication`

Can't get IntegratedSecurity with JDBC driver

`Connecting with Integrated Authentication`

Can't get IntegratedSecurity with JDBC driver

`Connecting with Integrated Authentication`

Sunday, March 25, 2012

Can't Generate SSPI

Can't Find SQL Native Client in ODBC Connection Manager in SQL Server Open Database Connectivit

Can't Find SQL Native Client in ODBC Connection Manager in SQL Server Open Database Connectivit

Can't Find SQL Native Client in ODBC Connection Manager

Can't Find SQL Native Client in ODBC Connection Manager

Thursday, March 22, 2012

Can't find odbcping.exe

Monday, March 19, 2012

Can't deploy report on the reporting server

Can''t deploy managed assembly to Katmai

Can''t deploy managed assembly to Katmai

Wednesday, March 7, 2012

Can't Create New Database on Device via ActiveSync

Can't Create New Database on Device via ActiveSync

connect from ASP app

Blog Archive

About Me