Programming Help

Web Development



What's Here?

  • Members: 132,605
  • Replies: 471,695
  • Topics: 73,132
  • Snippets: 2,541
  • Tutorials: 666
  • Total Online: 916
  • Members: 59
  • Guests: 857

Who's Online?

Welcome to Dream.In.Code
Getting Help is Easy!

Join 132,605 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 916 people online right now. Registration is fast and FREE... Join Now!




MS SQL problems !

 
 Reply to this topicStart new topic

MS SQL problems !
vb6_god
post 11 Jul, 2008 - 03:12 PM
Post #1


New D.I.C Head

*
Joined: 3 Dec, 2007
Posts: 26


My Contributions
Hi people,

I`m using a OLEDB connection in dreamweaver to connect to my MS SQL database ....the connection etc works fine.
But... I was wondering if anyone could help me with a problem.

First of all.. are there any implications with accessing a MS SQL database via MS ACCESS (if not how can i connect)??
and also I've tried using other applications to connect..... I can establish a connection but the database draws a blank
i.e. I connect but nothing shows up ???

Any ideas ???? Tips ....help

Thanx

-Mike
User is offlineProfile CardPM

Go to the top of the page

Footsie
post 12 Jul, 2008 - 02:32 AM
Post #2


D.I.C Regular

Group Icon
Joined: 20 Sep, 2007
Posts: 303



Thanked 4 times

Dream Kudos: 50
My Contributions
I'm not sure you are able to connect to MS SQL from MS ACCESS - They are both databases. You will want to connect from your application to either a SQL database or an Access database.

To get something to show up you need to use a SELECT statement to pull data out of the database table.
Something like SELECT * FROM yourTableName
Post your SELECT statement if you are doing this so someone can help.
User is offlineProfile CardPM

Go to the top of the page

dineeshd
post 12 Jul, 2008 - 02:55 AM
Post #3


D.I.C Addict

Group Icon
Joined: 30 Jun, 2008
Posts: 560



Thanked 16 times

Dream Kudos: 575
My Contributions
QUOTE(vb6_god @ 12 Jul, 2008 - 04:42 AM) *

First of all.. are there any implications with accessing a MS SQL database via MS ACCESS (if not how can i connect)??


Accessing MS SQL via MS Access is not seems to be very feasible. If you explain why you want access MS SQL via MS Access, we may be able to suggest some other work around for that.
User is offlineProfile CardPM

Go to the top of the page

vb6_god
post 17 Jul, 2008 - 06:30 PM
Post #4


New D.I.C Head

*
Joined: 3 Dec, 2007
Posts: 26


My Contributions
Problem solved i had the wrong database connection string

User is offlineProfile CardPM

Go to the top of the page

Trogdor
post 18 Jul, 2008 - 02:39 AM
Post #5


D.I.C Addict

Group Icon
Joined: 6 Oct, 2006
Posts: 517



Thanked 3 times

Dream Kudos: 125
My Contributions
Ofcourse you had the wrong database connection string.
Doesnt mean it makes sense to use access to connect to sqlserver.
The sqlserver management tools that come with it you can also install by itself. Why not use that?
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 11/23/08 02:23AM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month