CodeVerge.Net Beta


   Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums




Can Reply:  No Members Can Edit: No Online: Yes
Zone: > Asp.Net Forum > starter_kits_and_source_projects.commerce_starter_kit Tags:
Item Type: Date Entered: 10/2/2005 4:45:45 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
NR
XPoints: N/A Replies: 3 Views: 30 Favorited: 0 Favorite
4 Items, 1 Pages 1 |< << Go >> >|
"Suranjith" <>
NewsGroup User
SQL Server does not exist or access denied10/2/2005 4:45:45 PM

0

Hi,
I have downloaded the Commerce starter kit.
I 'm trying to connect to sql database through visual studio .net
 
but I getting this error

SQL Server does not exist or access denied
Line 63:
Line 64:             // Execute the command
Line 65:             myConnection.Open();
Line 66:             SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
Line 67:

Even through the through the installation the connection was succesfull all the tables were created in the commerce database in my SQl server.

please help me My question is why is not connecting to the sql database.

thanks
janaka
"Spire128" <>
NewsGroup User
Re: SQL Server does not exist or access denied10/2/2005 8:17:24 PM

0

Hi

You need to chabge this line in the wb config to point to your sever

<add key="ConnectionString" value="server=YourServer;uid=YourUserName;pwd=Yourpassword;database=Commerce" />


or if u are useing locale host server it will be something like below using your server name

<add key="ConnectionString" value="server=Desktop;Trusted_Connection=true;database=Commerce" />
"Suranjith" <>
NewsGroup User
Re: SQL Server does not exist or access denied10/3/2005 6:48:17 AM

0

Thanks for the reply

I 'm testing my SQL is in Local host.

my web config code is

<add key="ConnectionString" value="server=localhost;Trusted_Connection=true;database=Commerce" />

Still getting the same error

Do I need to change the computer name on this add key code
My computer name is "Galle"

I 'm having this problem for long time now
I can not connect any local SQL databases through Visual Studio .net
 
Please help
"Spire128" <>
NewsGroup User
Re: SQL Server does not exist or access denied10/3/2005 9:03:34 AM

0

Is the Sql server called localhost if the server name is called for example Desktop then u need to change it in the Web Config to your Sql server instance name, and check that the Sql server is set up for trusted permissions ie windows authentication
4 Items, 1 Pages 1 |< << Go >> >|


Free Download:









displaying localized currency info

collaborate?? only show products "in stock"

more characters in the product description field.

my version of store

about shoppingcart

why did author implement struct type for customerdetails, orderdetails, and productdetails ???

sql issue w/ registration

sql server does not exist or access denied.

configuration error

installing issue

ibuyspy store with access

problem with login.aspx

[byte]()

viewstate and header file issue

retrieving orders that have been placed

regarding ibuyspy.dll

has anyone integrated ibs portal modules with ibs store ?

windows server 2003 installation error

convert not to use dynamic urls

installing starter kit

productlist with 'linkbutton' - not usual 2 form problem

procedure 'crmc_productdetails' expects parameter '@color', which was not supplied

how can do a new

bug mk.bat error

page_init 'please explain this'

does csk offer multi-lingual support?

my implementation of the commerce starter kit

addtocart.aspx response.redirect("shoppingcart.aspx")

access is denied

deployed commerce starter kit

shopping cart

what are the security issues with the commerce starter kit?

urgent: my shopping cart cannot work properly

commerce starter kit for a live environment

after checkout

make a contact

latest version / difference between ibuyspy and commerce starter kit?

need help to run the ibuyspy store application

bug with shopping cart

microsoft visual web developer 2005 express edition starter kit inbuilt errors asp.net 2

what would this cost?????

shopping cart integration with existing dynamic catalog

changing the overall currency

commerce starter or portal starter?

where can i get a "plug and play" ibuystore?

can't download starter kits?

hosting the web site

newb, with dumb problems???

how to transfer customerid from orderlist.aspx to orderdetail.aspx

best way to process credit cards and payments with the commerce kit???
   
  Privacy | Contact Us
All Times Are GMT